package com.wyc.dao;

import com.wyc.pojo.HouseholdInformationSheet;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface HouseholdInformationSheetMapper {
    //普通管理员添加用户住房信息
    int addHouseInformation(HouseholdInformationSheet householdInformationSheet);
    //普通管理员检查身份证是否存在
    HouseholdInformationSheet findByCertificateNumber(String certificate_number);
    //普通管理员检查手机号是否重复
    HouseholdInformationSheet findByCellPhoneNumber(String cell_phone_number);
    //查询household_information_sheet有几条信息
    int getTotal();
    //普通管理员查询全部用户，返回到list集合
    List<HouseholdInformationSheet> queryAllUser(@Param("pageNum") Integer pageNum, @Param("pageSize") Integer pageSize);
    //普通管理员根据身份证查询用户信息
    List<HouseholdInformationSheet> selectByCertificateNumber(String certificate_number);
    //普通管理员根据id删除用户信息
    int deleteHouseholdInformationSheetById(Integer id);
    //普通管理员更新用户信息
    int updateHouseholdInformationSheet(HouseholdInformationSheet householdInformationSheet);
}
